MacWorld 1998 January/Macworld (1998-01).dmg/FileMaker Pro 4/FM4 Templates w⁄data/Business/Expenses System/Employee Names

FileMaker Pro Database | 1997-09-14 | 189KB | 1,057 lines

f4O2EcxglLx8O2huPcWv/zO3h8
/zb5/2LwNv7+jtH+aqicQWrha0Hod3gv40TzhiO8gQGll9RYL5WABbOGSuwTFuJN80fQGVz4mMZ2
IK+GOVzKtqih2gtKSQ1dobroPreETwiPU67yjvGLrk8uARWJ+Qy8z3RnCHuhHl11ojq2muMPQvsM
ZBxJZ+4ld9zpwu/GxHxQpelokPaCRzfe5EJi1aISVmaGBKZG4fuClCRUV1GPijvhgRNmmV12gvW+
ZLRWtzCLBqEW8S6humEP4mQUV7ZXCQWo6YneWcm3rdpaeLG4jYP3gY7w0/vW316q/B28eGyvcu2R
e2+tbdF8d4YepfVLjWuPFX45tiNtuvcVgBTqrKYWMOlV/k6mxDrElXp/QLGwkfUjCy0lzkA/CnL2
DeuzjhZ5/Tw0vjXD1AUPv491BdCkqcl9zz7vWTEITckLNISPIGUv7eKqox4cAPcLapCjVBKwmjT3
HBAM2016AUG95
Pro 3.0
nvoice-processing. You can also add fields and edit value lists to reflect your own products and services.
y-Billing, Invoicing , Sales, Inventory Controlz
10/24/95{
10/26/95
Paul Farrah
Business
-Y    Timecards
Description
This database keeps track of employee hours, and is based on the standard employee
ding a summary field for each time category.
Finance, Payroll, Timez
10/24/95{
10/24/95
Paul Farrah
Business
HBAM3016AUG95@
davidsonA
jackC
longC
julieA
julie
davidsonA
longC
pamelaB
pamela
HP DeskJet 540 Printer
d improperly (Jthe TCP/IP address is already in use or an address could not be obtained (
; This file is created and used by FileMaker Pro for TCP/IP access.
; It should contain one IP address or host name per line.
; Lines starting with a semicolon are ignored.
FileMaker Hosts
Local Hosts
Specify Host...:FileMaker host name is limited to 32
Pro 2.0 - 2.1F!
Pro 3.0 - 4.0
CREATED BY
DATE CREATED
DATE MODIFIED
DATE OF BIRTH
DATE OF HIRE
DATE OF NEXT REVIEW
DEPARTMENT
EMERGENCY CONTACT
EMERGENCY PHONE
EMPLOYEE ID
EMPLOYMENT TYPE
FIRST NAME
    FULL NAME
GENDER
     HOME CITY
HOME PHONE
HOME STATE
HOME STREET
HOME ZIP CODE
LAST LAYOUT
.    LAST NAME
MANAGER
MANAGER ID
NOTES
    PAY GRADE
PHONE\EXTENSION
PHOTO
SALARY
SOCIAL SECURITY NUMBER
TITLE
Employee IDB
First NameB
SalaryB
DepartmentB
ManagerB
Pro 2.0 - 2.1F!
Pro 3.0 - 4.0
    USENG.NDX
Sunday
Monday
Tuesday
    Wednesday
Thursday
Friday
Saturday
January
February
March
April
August
    September
October
November
December
1st Quarter
2nd Quarter
3rd Quarter
4th Quarter
7/29/975
Description
You can use this database file to maintain employee data such as hire date, salary, manager, department, pay grade, and next review date. You can also include personal information.
How to use this solution
Use the phone dialing feature to quickly dial the employee's extension. In an emergency, you can click the telephone icon next to the emergency contact information to call the contact person. You can edit your phone dialing preferences in the Preferences dialog box.
How to B
customize this solution
You can create a layout to print employee identification badges. You can also integrate this database with other databases, such as "Expense Reports" using lookups and relations.
Form View - Job
A    List View
Employee Phone List
Information
Report Menu
A    Pay GradeB
TitleB
Home StreetB
A    Home CityB
Home StateB
Home ZIP CodeB
NotesB
Phone\ExtensionB
Date CreatedB
Date ModifiedB
Social Security NumberB
X1Please enter a number in the form of 000-00-0000.
 ) = 11 )
GenderB
Date of BirthB
Date of HireB
Date of Next ReviewB
Home PhoneB
Employment TypeB
PhotoB
Emergency ContactB
Emergency PhoneB
InfoB
Created ByB
Last LayoutB
/A    Full Name
 & " " &
Manager IDB
Form View - JobB
Form View - Personal
A    List ViewB
Your Own
Buttons
Your Own
Buttont
Recordu
Delete
Recordv
Recordw
Reportsx
View As
Listy
View As
Formz
Close{
Info|
Employment Type}
Social Security No.~
Date of Hire
Next Review
Salary
A    Pay Grade
Phone/Ext.
Department
Title
F    Last Name
First Name
I,Enter Job Position information for Employees
Personal
Information
Position
P    Employees
Expenses File...
Notes
Manager
Manager ID
Line Items File...
Employee Phone ListB
Phone\Ext.P
DepartmentQ
TitleR    Last NameS
First NameT
Your Own
ButtonU
Your Own
ButtonV
RecordW
Delete
RecordX
RecordY
ReportsZ
View As
List[
View As
Form\
Close]
Info^-Click to see more information for an Employee
InformationB
Your Own
Buttonn
Reportso
View As
Listp
View As
Formq
Closer
Infos
Phonet
Departmentu
Titlev    Last Namew
Page ##y
Employee Phone Listz
First Name{
Employee Phone List
Report MenuB
Your Own
ButtonI
ReportsJ
View As
ListK
View As
FormL
CloseM
InfoO-Information about the Employee Names solutionP
Info for this Solution
about the Employee Names solutionP
Info for this Solution
Your Own
ReportB
Your Own ReportC
Your Own ReportD
Employee Phone ListE
Your Own
ButtonF
ReportsG
View As
ListH
View As
FormI
CloseJ
InfoK>Click on any of these buttons to preview the respective reportL
Select a report
ButtonF
ReportsG
View As
ListH
View As
FormI
CloseJ
InfoK>Click on any of these buttons to preview the respective reportL
Select a report
Form View - PersonalB
Your Own
ButtonB
ReportsC
View As
ListD
View As
FormE
CloseF
Your Own
Button{
Your Own
Button|
Record}
Delete
Record~
Record
Reports
View As
View As
Close
Emergency
Phone
Emergency Contact
Gender
G    Birthdate
Phone
ZIP Code
Address
U(Enter Personal Information for Employees
Z    Employees
Expenses File...7
Your Own
Button{
Your Own
Button|
Record}
Delete
Record~
Record
Reports
View As
View As
Close
Emergency
Phone
Emergency Contact
Gender
G    Birthdate
Phone
ZIP Code
Address
U(Enter Personal Information for Employees
Z    Employees
Expenses File...
Line Items File...
Personal
Information
Position
First Name
    Last Name
Phone/Ext.
Title
Department
Notes
DavidsonD
JulieE
125000G
Human ResourcesK
DirectorO
839 Eighth Ave.P
Foster CityQ
94401U
7393Y
10/19/95_
123-45-6789`
Malea
05/01/62e
05/02/95f
6/1/95g
415-555-0900h    Full Timei
Jack Davidsonk
408-555-2211o
Julie Davidson
PamelaE
65000G
Human ResourcesH
Julie DavidsonK
ManagerO
466 West Ave.P
EckmanQ
24829U
7396Y
10/19/95_
111-23-9845`
Femalea
09/21/61e
5/18/93f
5/18/96g
712-555-5245h    Full Timei
nj    Peter Dayk
712-555-6357o
Pamela Dayq
LongD
JackE
32000G    MarketingK
Marketing SpecialistO
88 Liberty St.P
GrotonQ
01450U
3785Y
10/19/95_
456-66-9877`
Malea
3/15/65e
4/3/91f
4/3/96g
508-555-6899h    Full Timei
Gertrude Longk
608-555-6513o    Jack Long
Your Own
ButtonB
ReportsC
View As
ListD
View As
FormE
CloseF
Open Script
Dial Extension
Dial Home Phone
Dial Emergency Phone
)=400
Cancel
You did not enter any find criteria; all records will be displayed.C)
Cancel
No records match this request.E)
Information
A    List View
Report Menu
Open Employee Expenses File
Open Expense Line Items File
Shutdown Script
Open Employee Expenses File
Open Expense Line Items File
Information
    List View
Report Menu
Sort by Department
Sort by Last Name
Employee Phone List
Open Script
Dial Extension
Dial Home Phone
Dial Emergency Phone
Shutdown Script
Sort by Last Name
Sort by Department
Employee Phone List
wwwwww
    ffffff
UUUUUU
DDDDDD
3333B
""""""
wwxwwxw
ggvgvv
gvwxgwghg
vhgvvww
fvfgfwffv
eVefefe
VvffVefVVefUe\
ffFdeefeefddfDeVdfEdfFdffk
EUeFFEUFEUFFUeTeVFeUUdVEEk
UTdUTeETeETeEUFTUTUFTUUTeK
TEETEETUETUETUDUDEETUDTUE[
4CDD4E4ET
D4DD4CDDC
C3C3C34C4C3CC43C
"#""3"129
#11#22122"3!
#11#22122"3!
"#""3"129
C3C3C34C4C3CC43C
DDCD4DD4CDDC
4CDD4E4ET
TEETEETUETUETUDUDEETUDTUE[
dUTeETeETeEUFTUTUFTUUTeK
EUeFFEUFEUFFUeTeVFeUUdVEEk
ffFdeefeefddfDeVdfEdfFdffk
eVefefe
VvffVefVVefUe\
fvfgfwffv
ggvgvv
gvwxgwghg
vhgvvww
Ejwwg
wwxwwxw
:NAME
FPTHA:HARDDISK:CONSULT:ClarisII:v3:qafirst:Employee expenses.fp3
NAMEA
Employee expenses.fp3
RPTHA
Employee expenses.fp3
SRPTA
emp_exp.fp3
WSPCA C:\CONSULT\ClarisII\v3\qafirst\
;NAME
FPTHA;HARDDISK:CONSULT:ClarisII:v3:qafirst:Expense Line Items.fp3
NAMEA
Expense Line Items.fp3
RPTHA
Expense Line Items.fp3
SRPTA
exp_itms.fp3
WSPCA C:\CONSULT\ClarisII\v3\qafirst\
eRPTH
FPTHAeGrendal:Applications:FileMaker Pro 4.0:FileMaker Templates:Business:Expenses System:Employee Expenses
MSPCA
NAMEA
Employee Expenses
RPTHA
Employee Expenses
alisVDEF
(LIST
VDEFA(
Managers
wwwwww
    ffffff
UUUUUU
DDDDDD
wwffeffg@
veUEDDCC
vUTDD44
vUDDC32
#""#
weUDD3
veTDC2233#3#2
wUDDC3##"
wwwwww
    ffffff
UUUUUU
DDDDDD
#4EWp
"4EVx
#3EVg
"4DUg
"#4DVg
24EVgy
"34EVw
##4Efw
""3DUgw
""33DUfw
""34DVgx
""#34EVgx
"#33DEfw
"    234DUfw
2""2334DEVgx
3    4DEUfwx
vUTD3#22
vUDDC
fUD42233##3#"!
vTDCC##"
eUDC3223##
fTD4C3##23#""
uTDC3323#2""!
22"2"
##2"!
fTDD33#22""
vUDC32"2""
WUTC22
eTD3#""
GDC32"!!
eD3#"!
T32""
"%UR
UD33D
3    DDUVgw
D    EUUfwx
UDDEUUfgw
U    Vfgwx
eUVfgww
B"#B@
B"#B"$
4"2$B"#B"#C
2$""#B"#C0
4"2#B"#C0
2$B"D0#C0
4""#C0
AD@D@
AD@D@
44444
CCCCC 44444 CCCCC
$42"
@@BA@
bRBBP0
UUUUU
 JJJJ
!BBBB
"99BB
#9999
$9911
%1111
&))))C
'!!!!
 *00**-
*00-00
00*0)
00*&0#
## !0*!%00+#!*0##-0'"0*#%00.!
(*)(%,3&
)%+@6)
",30,)%
UUUUUU
wwwwww
 #*>A6332+$"!
25,878
#&$690*"
!)0,++)(
 "%/66435/'#
+3;4*=
!#,@9,)+,(""(-/,,*,1!
!$&(265389,#!$$
'275?
$*23/$
$),-..)''
!$&)(-5439@1!!&*-3/)!!%6B)
)220(!$*.,,.'
!$&*,*023:?B+*.,/3254.'
"++,3/(.584.,"
!#&+/-./3:9@G@60/16883)!
$++//'(9CD>4.$$
$%)*-//2693,.075-&)3792,$
")-1347<>@G71(!
**)&'*.0350+%(=A2'%)579<94(
+/11!
!%'),342)1?=0)"
.1,$',-01)*).AG6-/048:<H
/2583$%+66/%
 %)++*),+&%06,%$#
!/40')-/31$$,@HFC<6887:==@B7%!
6A235,%
+,/13.%#"(16+
!#$(04-$&+,+$
%2>D6,59:989889=0
,.22<=33*
.22671#
!!&/42&
*1$&+,/3779733,
 $$PQ
/004B6*
!$$ $))'/3)
%&$&.7;4
)2$)*3-)466/%$
!),02+'
%$5)%*+%$!
(+'0:==4
$+,,1643"%)"
!)/1)*+
+7=-%%&$!
!3)3=.
%&*/3113
 !$$PQ
',4-%)/)
,6/%$$"
+(!<-
%),0354-
.13-&,-*
14'$$!
%))&%$!
'3*$$"
!&$%3
&%"%&
9836'
)&#%%!
$*)++"
.-/:%
!"&)()15,
)" /.-+)!L
//6B&
 #'*,.42$
$/,-*%
IF1A1
"%.2/-*#!
$/.,*($!#$"%PQ
#57-*'$#"$&'
..//.-,)'(.212PQ
",,)&%'.;<6/+',,)%!
'//,+//*)+.4:=>PQ
$(&(),5?@:2/,,''*$
-!,,%.0%)./7
#43((+9CA=3+N
&*)2!$96;;48@??PQ
)/01%$
#3/').:@<3)$&)!
/)4$%)8=A@?><@PQ
!.0/.+//./1//*
*.').3784/%
,,#%()25:<99=PQ
%10//O
0 /+134,.25653."
)++-!
# %0,*,384'%PQ
42//11/&(/563135650(
(./36$
!"23.,27-
6:=<)&931-13-!$.69433563+
,/258 #$,96-37)$!P
38;?B>;63/.22.-068934673(
,638<6$
*),/6."')==138*$)PQ
35:=@B>953-/1.-368<:8995&
%668:9(
)$'*.:&$*==8/,
-19=@CA>:83+2.,0157:
!""/88$
!)*# 6/0%
&' !$*38,.<;60"
+07=@CD=6>@.*)&(*-03;@@<-
6.3/%
#/23989=2,*%
/039>B@ "9E7,)+/3667:?CE/!"
$$%199207/
9K8@)
3933"
!0042381%$(.-)56PQ
556:=@@
5C958=BGGA96;='"+-
!!%.R
94.6BDCFM='(204967&
//2346%
$59232$PQ
:9<@?@C% 6D;;CJLONG952
(9304=FCDDE>%
$,585'
!.//11'$/;81$
9:CE><D3,5G@@HF>IF94)
$#%+*159C=:>FG)
*31*#
$/51#
89C=.!:9=C<9AFGS
CA7&(
/%3%!'+5A<6=C>$
-672.3<<961.%!
,,%=<9/69/02.
"773//33/,+)
/1$'9<3)"
069850(*)'%
%/+$
!&##34
%0<PQ
%"$:C9.*$
!+6@PQ
"$$6CD>>5
!##()
".;CPQ
 %'0>GFA:378+&&%$$,&
,:CPQ
$(,0V
27CGG@6681//,)%$/
'7CPQ
!%*/1,/44CC;6547@=2*!%.$
%;CPQ
'$)=3
 #%)*())3DLHB
?MB9/% !
"'6?6$
*;=PQ
$%&,9D6
!$%#"&)-:FIJHFGFBN@91)%"#(,/./:/#$-46PQ
!)/38;@(
"$$!"+29?DGIJKMLEIC83)'&-7:73)%$!!,5:PQ
+/0,$%&%%,26:5)
"$%&(/7;<=BGIJIGMG=953'%(1<<63/!
$*.8PQ
6=@?<3),3:8$
!&((),3=;::=EHIC:<F3)'""#&+/,',
#&(0PQ
FC8:CF@7/08<(
"'()*,169?:6=C=2..3'"
"%&)PQ
HD99=A@9534/
!26(%5,
! !),''*-16<@=430/,+/)!
??979>@@:-!
!$+%-*),/37<@:2/-*)+*"
4?=95;@@9&
*#%.,/136884/,)'),,%)+(%$$
/>C:13?@9)$
!!89+
!)$%*-/13321/,Z
*3*)-/0/+&$$!
 6A:0,8B=1+)/68.%/(,9=2%
")$"%)-02331/31)/().241+%##!
*79/)/:<651/33)2<8.6=9.
!$%,56643/75,'&).340+&#!$$%#!
.5.)/46682%#$$-973:=<7[
!$'+4:964063+(
,33/+(&'),*)'#
"%%.2379:1&"%(&.36@?@D5
!$%')/8:86>=2)&!!-231
34772+*
 &46339C@4+,3/)/:<D/8J='
"%'))+336@3(/)%#%,34569<=?CE5,)!
 #'21\
.7@C>9;99<9@CAE05J?,%$(.33/+,/26/)(,&
#,0258<?ADGE2 "'(#
"%),,/6983$
&4<9+4DD>?J>/*-6;<6,,/25.))3,'
",.0369;=AGE.
!%%(,.040'
2A?EA4*+/683*.493/($!/-,
0246689:AC7%
$%##(.23&
:96,#"%)*(%(364,%"!!"560&)/<9;989;>3$
"03., PQ
UUUUUU
wwwwww
~ffff
ffffff
ffff33
ff33ff
ff3333
33ffff
33ff33
333333
wwwwww
UUUUUU
DDDDDD
""""""
alisA
Gender ListB
Employment Type ListC
Manager List
FMRLA
Managers
    Helvetica
Geneva
Times
Times New Roman
Arial
MS Sans Serif
Courier
Courier New
wwwwww
    ffffff
UUUUUU
DDDDDD
3333B
""""""
A    Last NameB
First NameB
SalaryB
DepartmentB
ManagerB
nes starting with a semicolon are ignored.
FileMaker Hosts
Local Hosts
Specify Host...:FileMaker host name is limited to 32
fRPTH
FPTHAfGrendal:Applications:FileMaker Pro 4.0:FileMaker Templates:Business:Expenses System:Expense Line Items
MSPCA
NAMEA
Expense Line Items
RPTHA
Expense Line Items
Grendal
Expense Line Items
FMP3FMP3
Expenses System
fGrendal:Applications:FileMaker Pro 4.0:FileMaker Templates:Business:Expenses System:Expense Line Items
SCW-InfoMgmt
Kevster (7100/66)
Grendal
Kevin Jundt
Grendal
Employee Expenses
FMP3FMP3
Expenses System
eGrendal:Applications:FileMaker Pro 4.0:FileMaker Templates:Business:Expenses System:Employee Expenses
SCW-InfoMgmt
Kevster (7100/66)
Grendal
Kevin Jundt
(LIST
LISTA
Female
VDEFA(
(LIST
LISTA*Full Time
Part Time
Contractor
Temporary
VDEFA(
(LIST
VDEFA(
VPNRJ1J0F2J1VOZ
RQRQ^
R/RQRrVpVpVsV
VqRORQRPI
RQR1=
J0Vs9
ZRVp1G
R1RQA
J1R0E
N0N1E
-RooX
v0v0v
v0zPvRvQz2v3z1z
v1zRzszSzR~RzRz
z2"~1v1r
RSRSF
RtNsA
qJQ5j
/N3w[
3^-ZOj
^0frjOnsrrZ
/J-sy
JQNtNRJ0=
JrF1=
rVoN,R/NPVnf
r1r1m
J4JvN
>3B3F3F4BS>2B
B3F3B
B3>2B3B4>4B3B4B
>3>3B3
0Rsg8
JtF3B
F4B4B3>
B2F3B
>4B3B1B0B
#f/f.a
F3B4B4>
F3B3B3BSB4>
B3F4B4B3B
B3B2B
>4>49
f/f/a
B3B4F3B
>4>4:
B3B4B3B
FT>35
f/f/j.f
B3F4F4F3>
>4>4F4B4>4:
3>3B3B4B3>2B3B4B4B
f/f.f
F4BUB4B3>3BUB4B4>
B4>4B3B4B
>4>4B3F
F4FTF4B3B
B4>5>49
4>4>4B4B3>3>
>3>3B2F3>
F4JSBTB3B2B3>4:
B4>4>4B4B4>
>3B4>
f/f0f/f
B3FTFUB4B3B
4B4>4B4B4>4>
B3B3>
B3>3>
B4BSB3B3B
B4B4B3B4B4>
B3BRB3B3FS9
F3B3B
B4B4>4>4B
>4BTB4B4>4B4>3>3B3BSB3>3>
VqJ.F
R.ROVpVqVpZ
N-R.VPZqb
VPZpZ
0^RfTr
n/vqnQj.a
rrnRvqz
ztrSj
nQrrv
vrvRrqvrrrb
nPvQvsrrrQrrj0I
/rQvrvqrPjP]
/npnqnQjOf
j/f.b
b-^/^
/rPzqz
nPf/]
vqnOf
PvqvrnN]
/vqvrj/Y
rQrRf0U
j/)f/b
b/f.a
f1j0n
j0r/rPrOn/j.j.jOj/b
f/n/r0r0j
n/n0rO
rP+nPrOr/j/a
n0r0r/j
r/rPrQvQvPvQvQrOj/a
r0j0j0n0r
vR.zRvQrPn
r0r0n0n
r/v1zRzrzrzqvQn0e
0v1v1rQn0n
v/vQzRzrz
zrrQf/]
r1vRv0q
r1vRvRr1r0n
r0r1vQzqzrvrjQf
v1zSz
/rRrRnQn1n
n0r1vQzqzQnQf1f
/r0v0n1j1n
n1r1vQvPv0n0j/j
n1r0r/r/n0n.n
j/n0n0n/n.j.j
j.n.n.j
j/j.f
f/j0f/b
f/j0f/b/Y
j/j/f/a
j/j/f
j/j0j
f/n0j
f.jPj/j
j/j/j
j1j1n1j0j/f
j0jPnPr0n0j/n
n/j/j/j
j.j0jPjPnOr0r0n1v0v/n
f/j0n1r/r/n0r1r1r0n
f0n1r0r0r1rRrRv1r0j
n1r1v2v2r1r0n
j0f/b
b0j0n0j0
f0j0f0f/]
VSN2J2J2N1N2RSV
b/j/n/jPjP
j1j1j0b
f/f/f
VsRRRRNSR1R/R0RRVs^
b/f/r0nQjQf0f1f0f1jQj1fPj1f1f0f
ZsVRR2N
b0j1rQnRfRf1j1jQjR
j1f0f
8&0F@EH
Dd<D8
b0j0nQnSjsfQjPjQjQfRfSfRjQf0f
<$8E8DDdH
@c4F8$@
f/jQrsrsjS
f1jRfQfPf
8#4%<dP
VPNRJ1J0F2J1VOZ
RQRQ^
R/RQRrVpVpVsV
+j,j+j*j
f    j+j+j*jKn+j
*j+j+n*n+n,j*j*jKn*n    j
n*nLnLrLnLj+j*j*n*r
n*j,n,r,n+n
j+n+n
n+n*j
r,n,j+j
r,n-j+j
n+n,j
j,j-j,n,n,n+n
n,#n-n,n
n,%r+r+n,n,n+j*j
n-r-r-rMnL
n,%n+r*n+n,r+n*n+j
j.n.rNrMnM
n+n,n-n,r+n-j
j/n/nOnNnNj-j
n,r-r-vMr.j
j/nOnOn.j
j-n.r/vOrOn0j/e
f/rOrPnOj0j0n0nQj1f
.rPrPj0f
VLVoZ
    R+VMZm^
RMVmZ
?NNVoZnVmZ
VnZoZ
NJ/N/N-F
OJ/RORON.J-A
.N/ZoVoVpVoRMJ
NOZpVoV
RNJ,I
oVpRpVoZ
RoRMR+J
VpNpZ
oRoROROVp^
VoVNVMVLN,I
NOVqVP9f
pVpNORn^
RoVoVnZmVLRMJ+A
VoJ.RrVpA
ZpRORMb
VnVn^